package fr.esiag.isidis.epp.repository;

public class SqlConstants {
	
//	CREATE TABLE POWER_WEIGHT(
//	IdSite 		VARCHAR(8) NOT NULL,
//	PDate 		int NOT NULL,
//	PHour		int NOT NULL,
//	Power		int,
//	Weight 		float,
//	PRIMARY KEY (IdSite,PDate,PHour),
//	CONSTRAINT FK_powerWeight_site FOREIGN KEY(IdSite) REFERENCES Site(IdSite),
//	INDEX powerWeight_index (PDate)
//);
	public static final String QUEYR_INSERT_INTO_CDC_WEIGHT = "INSERT INTO power_weight VALUES (?,?,?,?,?)";

//	CREATE TABLE SITE(
//	IdSite 		VARCHAR(8) NOT NULL PRIMARY KEY,
//	NAF			VARCHAR(45) NOT NULL,
//	BeginDate	int,
//	EndDate		int,
//	CONSTRAINT FK_site_activity FOREIGN KEY(NAF) REFERENCES ACTIVITY(NAF),
//	INDEX site_index (NAF)
//);
//
	public static final String QUEYR_INSERT_INTO_SITE = "INSERT INTO site VALUES (?,?,?,?) ";
	
//	CREATE TABLE ACTIVITY(
//	NAF 		VARCHAR(8) NOT NULL PRIMARY KEY,
//	Label 		VARCHAR(45) NOT NULL,
//	CONSTRAINT Activity_UK UNIQUE(NAF)
//);
//
	
	public static final String QUEYR_INSERT_INTO_ACTIVITY = "INSERT IGNORE INTO activity VALUES (?,?) ";
	
//	CREATE TABLE TEMPERATURE(
//	IdSite 		VARCHAR(8) NOT NULL,
//	TDate 		int NOT NULL,
//	THour 		int NOT NULL,
//	Temprature 	Float,
//	PRIMARY KEY (IdSite,TDate,THour),
//	CONSTRAINT FK_temp_site FOREIGN KEY(IdSite) REFERENCES Site(IdSite),
//	INDEX temperature_index (TDate)
//);
//
	
	public static final String QUEYR_INSERT_INTO_TEMPERATURE = "INSERT INTO temperature VALUES (?,?,?,?) ";
}
